--DO NOT MODIFY THIS FILE. IT IS ALWAYS OVERWRITTEN ON GENERATION.
--Static Data For Version 1.0.0.0

if (SERVERPROPERTY('EngineEdition') <> 5) --NOT AZURE
exec sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'

--INSERT STATIC DATA FOR TABLE [Condition]
SET identity_insert [dbo].[Condition] on
if not exists(select * from [dbo].[Condition] where ([ConditionId] = 1)) INSERT INTO [dbo].[Condition] ([ConditionId],[Name]) values (1,'New')
if not exists(select * from [dbo].[Condition] where ([ConditionId] = 2)) INSERT INTO [dbo].[Condition] ([ConditionId],[Name]) values (2,'Used')
if not exists(select * from [dbo].[Condition] where ([ConditionId] = 3)) INSERT INTO [dbo].[Condition] ([ConditionId],[Name]) values (3,'Certified Pre-Owned')
SET identity_insert [dbo].[Condition] off

--INSERT STATIC DATA FOR TABLE [UserType]
SET identity_insert [dbo].[UserType] on
if not exists(select * from [dbo].[UserType] where ([UserTypeId] = 1)) INSERT INTO [dbo].[UserType] ([Active],[Name],[UserTypeId]) values (1,'Individual',1)
if not exists(select * from [dbo].[UserType] where ([UserTypeId] = 2)) INSERT INTO [dbo].[UserType] ([Active],[Name],[UserTypeId]) values (1,'Dealer',2)
SET identity_insert [dbo].[UserType] off

if (SERVERPROPERTY('EngineEdition') <> 5) --NOT AZURE
exec sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'

